module.exports = {
  create: `INSERT INTO SystemParameter
     (Category, Value, SortValue, CreatedOn)
     VALUES(@category, @value, @sortValue, datetime('now'))`,

  checkParamExists: `SELECT COUNT(*) as total from SystemParameter WHERE Category=@category and Value=@value`,

  getByCategory: `SELECT * FROM SystemParameter WHERE Category=@category ORDER BY SortValue ASC, CreatedOn DESC`
}